package com.weizhong.update.appdb;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;

public class DBHelper extends SQLiteOpenHelper {

    private static final String DATABASE_NAME = "appupdate.db";
	private static final int DATABASE_VERSION = 1;

	public DBHelper(Context context) {  
        //CursorFactory设置为null,使用默认值  
        super(context, DATABASE_NAME, null, DATABASE_VERSION);  
    }  

	//数据库第一次被创建时onCreate会被调用  
	@Override
	public void onCreate(SQLiteDatabase db) {
		// TODO Auto-generated method stub
		db.execSQL("CREATE TABLE IF NOT EXISTS appentity" +  
                "(_id INTEGER PRIMARY KEY AUTOINCREMENT, bubbleid INTEGER," +
				" appName TEXT, packageName TEXT, apkSize TEXT, apkPath TEXT, verName TEXT," +
				" verCode TEXT, action INTEGER, updateDes TEXT, appType INTEGER," +
				" isDeskTop INTEGER,downloadSuccess INTEGER,updateSuccess INTEGER,downloadid INTEGER)"); 
	}

	//如果DATABASE_VERSION值被改为2,系统发现现有数据库版本不同,即会调用onUpgrade  
	@Override
	public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
		// TODO Auto-generated method stub
		db.execSQL("ALTER TABLE appentity ADD COLUMN other STRING");  
	}
}
